<PackageChanges>
	<Component Name="Get Source query from meta" URL="Package=Load_MSOIndividualProfile/Executable=Get Source table query/Executable=Get Source query from meta">
		<Properties>
			<Property Name="SqlStatementSource" Value="[GetETL_SourceSystemQuery] 'MSO','IndividualAddress',?,0, ?" />
		</Properties>
	</Component>
	<Component Name="Truncate Staging Table" URL="Package=Load_MSOIndividualProfile/Executable=Get Source table query/Executable=Truncate Tables/Executable=Truncate Staging Table">
		<Properties>
			<Property Name="SqlStatementSource" Value="IF EXISTS(SELECT top 1 * from MSO_IndividualAddress) BEGIN TRUNCATE TABLE MSO_IndividualAddress END" />
		</Properties>
	</Component>
	<Component Name="Truncate GenevaOne Table" URL="Package=Load_MSOIndividualProfile/Executable=Get Source table query/Executable=Truncate Tables/Executable=Truncate GenevaOne Table">
		<Properties>
			<Property Name="SqlStatementSource" Value="IF EXISTS(SELECT top 1 * from MSO_IndividualAddress) BEGIN TRUNCATE TABLE MSO_IndividualAddress END" />
		</Properties>
	</Component>
	<Component Name="Source" URL="Package=Load_MSOIndividualProfile/Executable=Get Source table query/Executable=Full Extract/Executable=Source to Staging/Component=Source">
		<Mappings>
			<Mapping Usage="True" SourceColumn="UpdatedDate" DestinationColumn="UpdatedDate" />
			<Mapping Usage="True" SourceColumn="ContactAuthorizationThirdPartyID" DestinationColumn="ContactAuthorizationThirdPartyID" />
			<Mapping Usage="True" SourceColumn="IndividualId" DestinationColumn="IndividualId" />
			<Mapping Usage="True" SourceColumn="IndividualAddressID" DestinationColumn="IndividualAddressID" />
			<Mapping Usage="True" SourceColumn="Address1Txt" DestinationColumn="Address1Txt" />
			<Mapping Usage="True" SourceColumn="Address2Txt" DestinationColumn="Address2Txt" />
			<Mapping Usage="True" SourceColumn="Address3Txt" DestinationColumn="Address3Txt" />
			<Mapping Usage="True" SourceColumn="CarrierRouteCode" DestinationColumn="CarrierRouteCode" />
			<Mapping Usage="True" SourceColumn="CityName" DestinationColumn="CityName" />
			<Mapping Usage="True" SourceColumn="ContactAuthorizationID" DestinationColumn="ContactAuthorizationID" />
			<Mapping Usage="True" SourceColumn="CountryId" DestinationColumn="CountryId" />
			<Mapping Usage="True" SourceColumn="DepartmentName" DestinationColumn="DepartmentName" />
			<Mapping Usage="True" SourceColumn="DSFAddressTypeID" DestinationColumn="DSFAddressTypeID" />
			<Mapping Usage="True" SourceColumn="DSFDeliverabilityID" DestinationColumn="DSFDeliverabilityID" />
			<Mapping Usage="True" SourceColumn="IndividualAddressTypeID" DestinationColumn="IndividualAddressTypeID" />
			<Mapping Usage="True" SourceColumn="JobTitle" DestinationColumn="JobTitle" />
			<Mapping Usage="True" SourceColumn="LocalityName" DestinationColumn="LocalityName" />
			<Mapping Usage="True" SourceColumn="NCOAUndeliverableTypeID" DestinationColumn="NCOAUndeliverableTypeID" />
			<Mapping Usage="True" SourceColumn="PostalCode" DestinationColumn="PostalCode" />
			<Mapping Usage="True" SourceColumn="PostalCodeSuffix" DestinationColumn="PostalCodeSuffix" />
			<Mapping Usage="True" SourceColumn="ReportedUndeliverableID" DestinationColumn="ReportedUndeliverableID" />
			<Mapping Usage="True" SourceColumn="StateOrProvinceCode" DestinationColumn="StateOrProvinceCode" />
			<Mapping Usage="True" SourceColumn="TrilliumAddressQualityID" DestinationColumn="TrilliumAddressQualityID" />
		</Mappings>
	</Component>
	<Component Name="ExtractionID" URL="Package=Load_MSOIndividualProfile/Executable=Get Source table query/Executable=Full Extract/Executable=Source to Staging/Component=ExtractionID">
		<CollectionInformation>
			<Collection Name="Derived Column Output" Type="Output">
				<Properties />
				<Columns>
					<Column Name="ExtractionProcessID">
						<Properties>
							<Property Name="FriendlyExpression" Value="@[User::ExtractionProcessID]" />
							<Property Name="Expression" Value="@[User::ExtractionProcessID]" />
						</Properties>
					</Column>
				</Columns>
			</Collection>
		</CollectionInformation>
	</Component>
	<Component Name="Staging" URL="Package=Load_MSOIndividualProfile/Executable=Get Source table query/Executable=Full Extract/Executable=Source to Staging/Component=Staging">
		<Properties>
			<Property Name="OpenRowset" Value="MSO_IndividualAddress" />
		</Properties>
		<Mappings>
			<Mapping Usage="True" SourceColumn="IndividualId" DestinationColumn="IndividualId" />
			<Mapping Usage="True" SourceColumn="UpdatedDate" DestinationColumn="UpdatedDate" />
			<Mapping Usage="True" SourceColumn="ContactAuthorizationThirdPartyID" DestinationColumn="ContactAuthorizationThirdPartyID" />
			<Mapping Usage="True" SourceColumn="IndividualAddressID" DestinationColumn="IndividualAddressID" />
			<Mapping Usage="True" SourceColumn="Address1Txt" DestinationColumn="Address1Txt" />
			<Mapping Usage="True" SourceColumn="Address2Txt" DestinationColumn="Address2Txt" />
			<Mapping Usage="True" SourceColumn="Address3Txt" DestinationColumn="Address3Txt" />
			<Mapping Usage="True" SourceColumn="CarrierRouteCode" DestinationColumn="CarrierRouteCode" />
			<Mapping Usage="True" SourceColumn="CityName" DestinationColumn="CityName" />
			<Mapping Usage="True" SourceColumn="ContactAuthorizationID" DestinationColumn="ContactAuthorizationID" />
			<Mapping Usage="True" SourceColumn="CountryId" DestinationColumn="CountryId" />
			<Mapping Usage="True" SourceColumn="DepartmentName" DestinationColumn="DepartmentName" />
			<Mapping Usage="True" SourceColumn="DSFAddressTypeID" DestinationColumn="DSFAddressTypeID" />
			<Mapping Usage="True" SourceColumn="DSFDeliverabilityID" DestinationColumn="DSFDeliverabilityID" />
			<Mapping Usage="True" SourceColumn="IndividualAddressTypeID" DestinationColumn="IndividualAddressTypeID" />
			<Mapping Usage="True" SourceColumn="JobTitle" DestinationColumn="JobTitle" />
			<Mapping Usage="True" SourceColumn="LocalityName" DestinationColumn="LocalityName" />
			<Mapping Usage="True" SourceColumn="NCOAUndeliverableTypeID" DestinationColumn="NCOAUndeliverableTypeID" />
			<Mapping Usage="True" SourceColumn="PostalCode" DestinationColumn="PostalCode" />
			<Mapping Usage="True" SourceColumn="PostalCodeSuffix" DestinationColumn="PostalCodeSuffix" />
			<Mapping Usage="True" SourceColumn="ReportedUndeliverableID" DestinationColumn="ReportedUndeliverableID" />
			<Mapping Usage="True" SourceColumn="StateOrProvinceCode" DestinationColumn="StateOrProvinceCode" />
			<Mapping Usage="True" SourceColumn="TrilliumAddressQualityID" DestinationColumn="TrilliumAddressQualityID" />
			<Mapping Usage="True" SourceColumn="ExtractionProcessID" DestinationColumn="GENEVA_Staging_Extraction_id" />
		</Mappings>
	</Component>
	<Component Name="Log Task status" URL="Package=Load_MSOIndividualProfile/Executable=Get Source table query/Executable=Full Extract/Executable=Source to Staging/EventHandler=OnPostExecute/Executable=Log Task status">
		<Properties>
			<Property Name="SqlStatementSource" Value="&#xA;EXEC [dbo].[prc_Update_ETL_Log] ?, ?, ?, ?, ?, 0&#xA;/*&#xA; @RunID int,&#xA; @ExtractionProcessID INT,&#xA; @PackageName SYSNAME,&#xA; @SourceName SYSNAME,&#xA; @ExtractType bit,&#xA; @IsUpdate bit&#xA;&#xA;*/" />
		</Properties>
	</Component>
	<Component Name="Log Task status" URL="Package=Load_MSOIndividualProfile/Executable=Get Source table query/Executable=Full Extract/Executable=Source to Staging/EventHandler=OnPreExecute/Executable=Log Task status">
		<Properties>
			<Property Name="SqlStatementSource" Value="&#xA;EXEC [dbo].[prc_Update_ETL_Log] ?, ?, ?, ?, ?, 1&#xA;/*&#xA; @RunID int,&#xA; @ExtractionProcessID INT,&#xA; @PackageName SYSNAME,&#xA; @SourceName SYSNAME,&#xA; @ExtractType bit,&#xA; @IsUpdate bit&#xA;&#xA;*/" />
		</Properties>
	</Component>
	<Component Name="Staging" URL="Package=Load_MSOIndividualProfile/Executable=Get Source table query/Executable=Full Extract/Executable=Staging to GenevaOne (Full)/Component=Staging">
		<Mappings>
			<Mapping Usage="True" SourceColumn="IndividualId" DestinationColumn="IndividualId" />
			<Mapping Usage="True" SourceColumn="UpdatedDate" DestinationColumn="UpdatedDate" />
			<Mapping Usage="True" SourceColumn="ContactAuthorizationThirdPartyID" DestinationColumn="ContactAuthorizationThirdPartyID" />
			<Mapping Usage="True" SourceColumn="GENEVA_Deleted_Flag" DestinationColumn="GENEVA_Deleted_Flag" />
			<Mapping Usage="True" SourceColumn="GENEVA_Staging_Extraction_id" DestinationColumn="GENEVA_Staging_Extraction_id" />
			<Mapping Usage="True" SourceColumn="IndividualAddressID" DestinationColumn="IndividualAddressID" />
			<Mapping Usage="True" SourceColumn="Address1Txt" DestinationColumn="Address1Txt" />
			<Mapping Usage="True" SourceColumn="Address2Txt" DestinationColumn="Address2Txt" />
			<Mapping Usage="True" SourceColumn="Address3Txt" DestinationColumn="Address3Txt" />
			<Mapping Usage="True" SourceColumn="CarrierRouteCode" DestinationColumn="CarrierRouteCode" />
			<Mapping Usage="True" SourceColumn="CityName" DestinationColumn="CityName" />
			<Mapping Usage="True" SourceColumn="ContactAuthorizationID" DestinationColumn="ContactAuthorizationID" />
			<Mapping Usage="True" SourceColumn="CountryId" DestinationColumn="CountryId" />
			<Mapping Usage="True" SourceColumn="DepartmentName" DestinationColumn="DepartmentName" />
			<Mapping Usage="True" SourceColumn="DSFAddressTypeID" DestinationColumn="DSFAddressTypeID" />
			<Mapping Usage="True" SourceColumn="DSFDeliverabilityID" DestinationColumn="DSFDeliverabilityID" />
			<Mapping Usage="True" SourceColumn="IndividualAddressTypeID" DestinationColumn="IndividualAddressTypeID" />
			<Mapping Usage="True" SourceColumn="JobTitle" DestinationColumn="JobTitle" />
			<Mapping Usage="True" SourceColumn="LocalityName" DestinationColumn="LocalityName" />
			<Mapping Usage="True" SourceColumn="NCOAUndeliverableTypeID" DestinationColumn="NCOAUndeliverableTypeID" />
			<Mapping Usage="True" SourceColumn="PostalCode" DestinationColumn="PostalCode" />
			<Mapping Usage="True" SourceColumn="PostalCodeSuffix" DestinationColumn="PostalCodeSuffix" />
			<Mapping Usage="True" SourceColumn="ReportedUndeliverableID" DestinationColumn="ReportedUndeliverableID" />
			<Mapping Usage="True" SourceColumn="StateOrProvinceCode" DestinationColumn="StateOrProvinceCode" />
			<Mapping Usage="True" SourceColumn="TrilliumAddressQualityID" DestinationColumn="TrilliumAddressQualityID" />
		</Mappings>
	</Component>
	<Component Name="Row Count" URL="Package=Load_MSOIndividualProfile/Executable=Get Source table query/Executable=Full Extract/Executable=Staging to GenevaOne (Full)/Component=Row Count">
		<CollectionInformation />
	</Component>
	<Component Name="GenevaOne" URL="Package=Load_MSOIndividualProfile/Executable=Get Source table query/Executable=Full Extract/Executable=Staging to GenevaOne (Full)/Component=GenevaOne">
		<Properties>
			<Property Name="OpenRowset" Value="MSO_IndividualAddress" />
		</Properties>
		<Mappings>
			<Mapping Usage="True" SourceColumn="IndividualId" DestinationColumn="IndividualId" />
			<Mapping Usage="True" SourceColumn="UpdatedDate" DestinationColumn="UpdatedDate" />
			<Mapping Usage="True" SourceColumn="ContactAuthorizationThirdPartyID" DestinationColumn="ContactAuthorizationThirdPartyID" />
			<Mapping Usage="True" SourceColumn="GENEVA_Deleted_Flag" DestinationColumn="GENEVA_Deleted_Flag" />
			<Mapping Usage="True" SourceColumn="IndividualAddressID" DestinationColumn="IndividualAddressID" />
			<Mapping Usage="True" SourceColumn="Address1Txt" DestinationColumn="Address1Txt" />
			<Mapping Usage="True" SourceColumn="Address2Txt" DestinationColumn="Address2Txt" />
			<Mapping Usage="True" SourceColumn="Address3Txt" DestinationColumn="Address3Txt" />
			<Mapping Usage="True" SourceColumn="CarrierRouteCode" DestinationColumn="CarrierRouteCode" />
			<Mapping Usage="True" SourceColumn="CityName" DestinationColumn="CityName" />
			<Mapping Usage="True" SourceColumn="ContactAuthorizationID" DestinationColumn="ContactAuthorizationID" />
			<Mapping Usage="True" SourceColumn="CountryId" DestinationColumn="CountryId" />
			<Mapping Usage="True" SourceColumn="DepartmentName" DestinationColumn="DepartmentName" />
			<Mapping Usage="True" SourceColumn="DSFAddressTypeID" DestinationColumn="DSFAddressTypeID" />
			<Mapping Usage="True" SourceColumn="DSFDeliverabilityID" DestinationColumn="DSFDeliverabilityID" />
			<Mapping Usage="True" SourceColumn="IndividualAddressTypeID" DestinationColumn="IndividualAddressTypeID" />
			<Mapping Usage="True" SourceColumn="JobTitle" DestinationColumn="JobTitle" />
			<Mapping Usage="True" SourceColumn="LocalityName" DestinationColumn="LocalityName" />
			<Mapping Usage="True" SourceColumn="NCOAUndeliverableTypeID" DestinationColumn="NCOAUndeliverableTypeID" />
			<Mapping Usage="True" SourceColumn="PostalCode" DestinationColumn="PostalCode" />
			<Mapping Usage="True" SourceColumn="PostalCodeSuffix" DestinationColumn="PostalCodeSuffix" />
			<Mapping Usage="True" SourceColumn="ReportedUndeliverableID" DestinationColumn="ReportedUndeliverableID" />
			<Mapping Usage="True" SourceColumn="StateOrProvinceCode" DestinationColumn="StateOrProvinceCode" />
			<Mapping Usage="True" SourceColumn="TrilliumAddressQualityID" DestinationColumn="TrilliumAddressQualityID" />
			<Mapping Usage="True" SourceColumn="GENEVA_Staging_Extraction_id" DestinationColumn="GENEVA_ONE_Extraction_id" />
		</Mappings>
	</Component>
	<Component Name="Log Task status" URL="Package=Load_MSOIndividualProfile/Executable=Get Source table query/Executable=Full Extract/Executable=Staging to GenevaOne (Full)/EventHandler=OnPostExecute/Executable=Log Task status">
		<Properties>
			<Property Name="SqlStatementSource" Value="&#xA;EXEC [dbo].[prc_Update_ETL_Log] ?, ?, ?, ?, ?, 0&#xA;/*&#xA; @RunID int,&#xA; @ExtractionProcessID INT,&#xA; @PackageName SYSNAME,&#xA; @SourceName SYSNAME,&#xA; @ExtractType bit,&#xA; @IsUpdate bit&#xA;&#xA;*/" />
		</Properties>
	</Component>
	<Component Name="Log Task status" URL="Package=Load_MSOIndividualProfile/Executable=Get Source table query/Executable=Full Extract/Executable=Staging to GenevaOne (Full)/EventHandler=OnPreExecute/Executable=Log Task status">
		<Properties>
			<Property Name="SqlStatementSource" Value="&#xA;EXEC [dbo].[prc_Update_ETL_Log] ?, ?, ?, ?, ?, 1&#xA;/*&#xA; @RunID int,&#xA; @ExtractionProcessID INT,&#xA; @PackageName SYSNAME,&#xA; @SourceName SYSNAME,&#xA; @ExtractType bit,&#xA; @IsUpdate bit&#xA;&#xA;*/" />
		</Properties>
	</Component>
	<Component Name="Truncate Workarea" URL="Package=Load_MSOIndividualProfile/Executable=Get Source table query/Executable=Truncate Workarea/Executable=Truncate Workarea">
		<Properties>
			<Property Name="SqlStatementSource" Value="IF EXISTS(SELECT top 1 * from MSO_IndividualAddress) BEGIN TRUNCATE TABLE MSO_IndividualAddress END" />
		</Properties>
	</Component>
	<Component Name="Source" URL="Package=Load_MSOIndividualProfile/Executable=Get Source table query/Executable=Delta Extract/Executable=Source to Workarea/Component=Source">
		<Mappings>
			<Mapping Usage="True" SourceColumn="UpdatedDate" DestinationColumn="UpdatedDate" />
			<Mapping Usage="True" SourceColumn="ContactAuthorizationThirdPartyID" DestinationColumn="ContactAuthorizationThirdPartyID" />
			<Mapping Usage="True" SourceColumn="IndividualId" DestinationColumn="IndividualId" />
			<Mapping Usage="True" SourceColumn="IndividualAddressID" DestinationColumn="IndividualAddressID" />
			<Mapping Usage="True" SourceColumn="Address1Txt" DestinationColumn="Address1Txt" />
			<Mapping Usage="True" SourceColumn="Address2Txt" DestinationColumn="Address2Txt" />
			<Mapping Usage="True" SourceColumn="Address3Txt" DestinationColumn="Address3Txt" />
			<Mapping Usage="True" SourceColumn="CarrierRouteCode" DestinationColumn="CarrierRouteCode" />
			<Mapping Usage="True" SourceColumn="CityName" DestinationColumn="CityName" />
			<Mapping Usage="True" SourceColumn="ContactAuthorizationID" DestinationColumn="ContactAuthorizationID" />
			<Mapping Usage="True" SourceColumn="CountryId" DestinationColumn="CountryId" />
			<Mapping Usage="True" SourceColumn="DepartmentName" DestinationColumn="DepartmentName" />
			<Mapping Usage="True" SourceColumn="DSFAddressTypeID" DestinationColumn="DSFAddressTypeID" />
			<Mapping Usage="True" SourceColumn="DSFDeliverabilityID" DestinationColumn="DSFDeliverabilityID" />
			<Mapping Usage="True" SourceColumn="IndividualAddressTypeID" DestinationColumn="IndividualAddressTypeID" />
			<Mapping Usage="True" SourceColumn="JobTitle" DestinationColumn="JobTitle" />
			<Mapping Usage="True" SourceColumn="LocalityName" DestinationColumn="LocalityName" />
			<Mapping Usage="True" SourceColumn="NCOAUndeliverableTypeID" DestinationColumn="NCOAUndeliverableTypeID" />
			<Mapping Usage="True" SourceColumn="PostalCode" DestinationColumn="PostalCode" />
			<Mapping Usage="True" SourceColumn="PostalCodeSuffix" DestinationColumn="PostalCodeSuffix" />
			<Mapping Usage="True" SourceColumn="ReportedUndeliverableID" DestinationColumn="ReportedUndeliverableID" />
			<Mapping Usage="True" SourceColumn="StateOrProvinceCode" DestinationColumn="StateOrProvinceCode" />
			<Mapping Usage="True" SourceColumn="TrilliumAddressQualityID" DestinationColumn="TrilliumAddressQualityID" />
		</Mappings>
	</Component>
	<Component Name="ExtractionID" URL="Package=Load_MSOIndividualProfile/Executable=Get Source table query/Executable=Delta Extract/Executable=Source to Workarea/Component=ExtractionID">
		<CollectionInformation>
			<Collection Name="Derived Column Output" Type="Output">
				<Properties />
				<Columns>
					<Column Name="ExtractionProcessID">
						<Properties>
							<Property Name="FriendlyExpression" Value="@[User::ExtractionProcessID]" />
							<Property Name="Expression" Value="@[User::ExtractionProcessID]" />
						</Properties>
					</Column>
				</Columns>
			</Collection>
		</CollectionInformation>
	</Component>
	<Component Name="Workarea" URL="Package=Load_MSOIndividualProfile/Executable=Get Source table query/Executable=Delta Extract/Executable=Source to Workarea/Component=Workarea">
		<Properties>
			<Property Name="OpenRowset" Value="MSO_IndividualAddress" />
		</Properties>
		<Mappings>
			<Mapping Usage="True" SourceColumn="IndividualId" DestinationColumn="IndividualId" />
			<Mapping Usage="True" SourceColumn="UpdatedDate" DestinationColumn="UpdatedDate" />
			<Mapping Usage="True" SourceColumn="ContactAuthorizationThirdPartyID" DestinationColumn="ContactAuthorizationThirdPartyID" />
			<Mapping Usage="True" SourceColumn="IndividualAddressID" DestinationColumn="IndividualAddressID" />
			<Mapping Usage="True" SourceColumn="Address1Txt" DestinationColumn="Address1Txt" />
			<Mapping Usage="True" SourceColumn="Address2Txt" DestinationColumn="Address2Txt" />
			<Mapping Usage="True" SourceColumn="Address3Txt" DestinationColumn="Address3Txt" />
			<Mapping Usage="True" SourceColumn="CarrierRouteCode" DestinationColumn="CarrierRouteCode" />
			<Mapping Usage="True" SourceColumn="CityName" DestinationColumn="CityName" />
			<Mapping Usage="True" SourceColumn="ContactAuthorizationID" DestinationColumn="ContactAuthorizationID" />
			<Mapping Usage="True" SourceColumn="CountryId" DestinationColumn="CountryId" />
			<Mapping Usage="True" SourceColumn="DepartmentName" DestinationColumn="DepartmentName" />
			<Mapping Usage="True" SourceColumn="DSFAddressTypeID" DestinationColumn="DSFAddressTypeID" />
			<Mapping Usage="True" SourceColumn="DSFDeliverabilityID" DestinationColumn="DSFDeliverabilityID" />
			<Mapping Usage="True" SourceColumn="IndividualAddressTypeID" DestinationColumn="IndividualAddressTypeID" />
			<Mapping Usage="True" SourceColumn="JobTitle" DestinationColumn="JobTitle" />
			<Mapping Usage="True" SourceColumn="LocalityName" DestinationColumn="LocalityName" />
			<Mapping Usage="True" SourceColumn="NCOAUndeliverableTypeID" DestinationColumn="NCOAUndeliverableTypeID" />
			<Mapping Usage="True" SourceColumn="PostalCode" DestinationColumn="PostalCode" />
			<Mapping Usage="True" SourceColumn="PostalCodeSuffix" DestinationColumn="PostalCodeSuffix" />
			<Mapping Usage="True" SourceColumn="ReportedUndeliverableID" DestinationColumn="ReportedUndeliverableID" />
			<Mapping Usage="True" SourceColumn="StateOrProvinceCode" DestinationColumn="StateOrProvinceCode" />
			<Mapping Usage="True" SourceColumn="TrilliumAddressQualityID" DestinationColumn="TrilliumAddressQualityID" />
		</Mappings>
	</Component>
	<Component Name="Log Task status" URL="Package=Load_MSOIndividualProfile/Executable=Get Source table query/Executable=Delta Extract/Executable=Source to Workarea/EventHandler=OnPostExecute/Executable=Log Task status">
		<Properties>
			<Property Name="SqlStatementSource" Value="&#xA;EXEC [dbo].[prc_Update_ETL_Log] ?, ?, ?, ?, ?, 0&#xA;/*&#xA; @RunID int,&#xA; @ExtractionProcessID INT,&#xA; @PackageName SYSNAME,&#xA; @SourceName SYSNAME,&#xA; @ExtractType bit,&#xA; @IsUpdate bit&#xA;&#xA;*/" />
		</Properties>
	</Component>
	<Component Name="Log Task status" URL="Package=Load_MSOIndividualProfile/Executable=Get Source table query/Executable=Delta Extract/Executable=Source to Workarea/EventHandler=OnPreExecute/Executable=Log Task status">
		<Properties>
			<Property Name="SqlStatementSource" Value="&#xA;EXEC [dbo].[prc_Update_ETL_Log] ?, ?, ?, ?, ?, 1&#xA;/*&#xA; @RunID int,&#xA; @ExtractionProcessID INT,&#xA; @PackageName SYSNAME,&#xA; @SourceName SYSNAME,&#xA; @ExtractType bit,&#xA; @IsUpdate bit&#xA;&#xA;*/" />
		</Properties>
	</Component>
	<Component Name="Fetch Delta from WorkArea" URL="Package=Load_MSOIndividualProfile/Executable=Get Source table query/Executable=Delta Extract/Executable=WorkArea to Staging/Component=Fetch Delta from WorkArea">
		<Properties>
			<Property Name="SqlCommand" Value="SELECT IndividualAddressID,UpdatedDate,Address1Txt,Address2Txt,Address3Txt,CarrierRouteCode,CityName,ContactAuthorizationID,ContactAuthorizationThirdPartyID,CountryId,DepartmentName,DSFAddressTypeID,DSFDeliverabilityID,IndividualAddressTypeID,IndividualId,JobTitle,LocalityName,NCOAUndeliverableTypeID,PostalCode,PostalCodeSuffix,ReportedUndeliverableID,StateOrProvinceCode,TrilliumAddressQualityID FROM MSO_IndividualAddress" />
		</Properties>
		<Mappings>
			<Mapping Usage="True" SourceColumn="UpdatedDate" DestinationColumn="UpdatedDate" />
			<Mapping Usage="True" SourceColumn="IndividualId" DestinationColumn="IndividualId" />
			<Mapping Usage="True" SourceColumn="ContactAuthorizationThirdPartyID" DestinationColumn="ContactAuthorizationThirdPartyID" />
			<Mapping Usage="True" SourceColumn="IndividualAddressID" DestinationColumn="IndividualAddressID" />
			<Mapping Usage="True" SourceColumn="Address1Txt" DestinationColumn="Address1Txt" />
			<Mapping Usage="True" SourceColumn="Address2Txt" DestinationColumn="Address2Txt" />
			<Mapping Usage="True" SourceColumn="Address3Txt" DestinationColumn="Address3Txt" />
			<Mapping Usage="True" SourceColumn="CarrierRouteCode" DestinationColumn="CarrierRouteCode" />
			<Mapping Usage="True" SourceColumn="CityName" DestinationColumn="CityName" />
			<Mapping Usage="True" SourceColumn="ContactAuthorizationID" DestinationColumn="ContactAuthorizationID" />
			<Mapping Usage="True" SourceColumn="CountryId" DestinationColumn="CountryId" />
			<Mapping Usage="True" SourceColumn="DepartmentName" DestinationColumn="DepartmentName" />
			<Mapping Usage="True" SourceColumn="DSFAddressTypeID" DestinationColumn="DSFAddressTypeID" />
			<Mapping Usage="True" SourceColumn="DSFDeliverabilityID" DestinationColumn="DSFDeliverabilityID" />
			<Mapping Usage="True" SourceColumn="IndividualAddressTypeID" DestinationColumn="IndividualAddressTypeID" />
			<Mapping Usage="True" SourceColumn="JobTitle" DestinationColumn="JobTitle" />
			<Mapping Usage="True" SourceColumn="LocalityName" DestinationColumn="LocalityName" />
			<Mapping Usage="True" SourceColumn="NCOAUndeliverableTypeID" DestinationColumn="NCOAUndeliverableTypeID" />
			<Mapping Usage="True" SourceColumn="PostalCode" DestinationColumn="PostalCode" />
			<Mapping Usage="True" SourceColumn="PostalCodeSuffix" DestinationColumn="PostalCodeSuffix" />
			<Mapping Usage="True" SourceColumn="ReportedUndeliverableID" DestinationColumn="ReportedUndeliverableID" />
			<Mapping Usage="True" SourceColumn="StateOrProvinceCode" DestinationColumn="StateOrProvinceCode" />
			<Mapping Usage="True" SourceColumn="TrilliumAddressQualityID" DestinationColumn="TrilliumAddressQualityID" />
		</Mappings>
	</Component>
	<Component Name="ExtractionID Clone" URL="Package=Load_MSOIndividualProfile/Executable=Get Source table query/Executable=Delta Extract/Executable=WorkArea to Staging/Component=ExtractionID Clone">
		<CollectionInformation>
			<Collection Name="Derived Column Output" Type="Output">
				<Properties />
				<Columns>
					<Column Name="ExtractionProcessID">
						<Properties>
							<Property Name="FriendlyExpression" Value="@[User::ExtractionProcessID]" />
							<Property Name="Expression" Value="@[User::ExtractionProcessID]" />
						</Properties>
					</Column>
					<Column Name="Derived Column 1">
						<Properties>
							<Property Name="FriendlyExpression" Value="UpdatedDate" />
							<Property Name="Expression" Value="#6209" />
						</Properties>
					</Column>
				</Columns>
			</Collection>
		</CollectionInformation>
	</Component>
	<Component Name="OLE DB Destination" URL="Package=Load_MSOIndividualProfile/Executable=Get Source table query/Executable=Delta Extract/Executable=WorkArea to Staging/Component=OLE DB Destination">
		<Properties>
			<Property Name="OpenRowset" Value="MSO_IndividualAddress" />
		</Properties>
		<Mappings>
			<Mapping Usage="True" SourceColumn="UpdatedDate" DestinationColumn="UpdatedDate" />
			<Mapping Usage="True" SourceColumn="IndividualId" DestinationColumn="IndividualId" />
			<Mapping Usage="True" SourceColumn="ContactAuthorizationThirdPartyID" DestinationColumn="ContactAuthorizationThirdPartyID" />
			<Mapping Usage="True" SourceColumn="ExtractionProcessID" DestinationColumn="GENEVA_Staging_Extraction_id" />
			<Mapping Usage="True" SourceColumn="IndividualAddressID" DestinationColumn="IndividualAddressID" />
			<Mapping Usage="True" SourceColumn="Address1Txt" DestinationColumn="Address1Txt" />
			<Mapping Usage="True" SourceColumn="Address2Txt" DestinationColumn="Address2Txt" />
			<Mapping Usage="True" SourceColumn="Address3Txt" DestinationColumn="Address3Txt" />
			<Mapping Usage="True" SourceColumn="CarrierRouteCode" DestinationColumn="CarrierRouteCode" />
			<Mapping Usage="True" SourceColumn="CityName" DestinationColumn="CityName" />
			<Mapping Usage="True" SourceColumn="ContactAuthorizationID" DestinationColumn="ContactAuthorizationID" />
			<Mapping Usage="True" SourceColumn="CountryId" DestinationColumn="CountryId" />
			<Mapping Usage="True" SourceColumn="DepartmentName" DestinationColumn="DepartmentName" />
			<Mapping Usage="True" SourceColumn="DSFAddressTypeID" DestinationColumn="DSFAddressTypeID" />
			<Mapping Usage="True" SourceColumn="DSFDeliverabilityID" DestinationColumn="DSFDeliverabilityID" />
			<Mapping Usage="True" SourceColumn="IndividualAddressTypeID" DestinationColumn="IndividualAddressTypeID" />
			<Mapping Usage="True" SourceColumn="JobTitle" DestinationColumn="JobTitle" />
			<Mapping Usage="True" SourceColumn="LocalityName" DestinationColumn="LocalityName" />
			<Mapping Usage="True" SourceColumn="NCOAUndeliverableTypeID" DestinationColumn="NCOAUndeliverableTypeID" />
			<Mapping Usage="True" SourceColumn="PostalCode" DestinationColumn="PostalCode" />
			<Mapping Usage="True" SourceColumn="PostalCodeSuffix" DestinationColumn="PostalCodeSuffix" />
			<Mapping Usage="True" SourceColumn="ReportedUndeliverableID" DestinationColumn="ReportedUndeliverableID" />
			<Mapping Usage="True" SourceColumn="StateOrProvinceCode" DestinationColumn="StateOrProvinceCode" />
			<Mapping Usage="True" SourceColumn="TrilliumAddressQualityID" DestinationColumn="TrilliumAddressQualityID" />
		</Mappings>
	</Component>
	<Component Name="Staging Command" URL="Package=Load_MSOIndividualProfile/Executable=Get Source table query/Executable=Delta Extract/Executable=WorkArea to Staging/Component=Staging Command">
		<Properties>
			<Property Name="SqlCommand" Value="UPDATE MSO_IndividualAddress SET UpdatedDate = ?, Address1Txt = ?, Address2Txt = ?, Address3Txt = ?, CarrierRouteCode = ?, CityName = ?, ContactAuthorizationID = ?, ContactAuthorizationThirdPartyID = ?, CountryId = ?, DepartmentName = ?, DSFAddressTypeID = ?, DSFDeliverabilityID = ?, IndividualAddressTypeID = ?, IndividualId = ?, JobTitle = ?, LocalityName = ?, NCOAUndeliverableTypeID = ?, PostalCode = ?, PostalCodeSuffix = ?, ReportedUndeliverableID = ?, StateOrProvinceCode = ?, TrilliumAddressQualityID = ?, GENEVA_Staging_Extraction_id = ? WHERE IndividualAddressID = ? AND UpdatedDate &lt;&gt; ?" />
		</Properties>
		<Mappings>
			<Mapping Usage="True" SourceColumn="UpdatedDate" DestinationColumn="Param_0" />
			<Mapping Usage="True" SourceColumn="Address1Txt" DestinationColumn="Param_1" />
			<Mapping Usage="True" SourceColumn="Address2Txt" DestinationColumn="Param_2" />
			<Mapping Usage="True" SourceColumn="Address3Txt" DestinationColumn="Param_3" />
			<Mapping Usage="True" SourceColumn="CarrierRouteCode" DestinationColumn="Param_4" />
			<Mapping Usage="True" SourceColumn="CityName" DestinationColumn="Param_5" />
			<Mapping Usage="True" SourceColumn="ContactAuthorizationID" DestinationColumn="Param_6" />
			<Mapping Usage="True" SourceColumn="ContactAuthorizationThirdPartyID" DestinationColumn="Param_7" />
			<Mapping Usage="True" SourceColumn="CountryId" DestinationColumn="Param_8" />
			<Mapping Usage="True" SourceColumn="DepartmentName" DestinationColumn="Param_9" />
			<Mapping Usage="True" SourceColumn="DSFAddressTypeID" DestinationColumn="Param_10" />
			<Mapping Usage="True" SourceColumn="DSFDeliverabilityID" DestinationColumn="Param_11" />
			<Mapping Usage="True" SourceColumn="IndividualAddressTypeID" DestinationColumn="Param_12" />
			<Mapping Usage="True" SourceColumn="IndividualId" DestinationColumn="Param_13" />
			<Mapping Usage="True" SourceColumn="JobTitle" DestinationColumn="Param_14" />
			<Mapping Usage="True" SourceColumn="LocalityName" DestinationColumn="Param_15" />
			<Mapping Usage="True" SourceColumn="NCOAUndeliverableTypeID" DestinationColumn="Param_16" />
			<Mapping Usage="True" SourceColumn="PostalCode" DestinationColumn="Param_17" />
			<Mapping Usage="True" SourceColumn="PostalCodeSuffix" DestinationColumn="Param_18" />
			<Mapping Usage="True" SourceColumn="ReportedUndeliverableID" DestinationColumn="Param_19" />
			<Mapping Usage="True" SourceColumn="StateOrProvinceCode" DestinationColumn="Param_20" />
			<Mapping Usage="True" SourceColumn="TrilliumAddressQualityID" DestinationColumn="Param_21" />
			<Mapping Usage="True" SourceColumn="ExtractionProcessID" DestinationColumn="Param_22" />
			<Mapping Usage="True" SourceColumn="IndividualAddressID" DestinationColumn="Param_23" />
			<Mapping Usage="True" SourceColumn="Derived Column 1" DestinationColumn="Param_24" />
		</Mappings>
	</Component>
	<Component Name="Log Task status" URL="Package=Load_MSOIndividualProfile/Executable=Get Source table query/Executable=Delta Extract/Executable=WorkArea to Staging/EventHandler=OnPostExecute/Executable=Log Task status">
		<Properties>
			<Property Name="SqlStatementSource" Value="&#xA;EXEC [dbo].[prc_Update_ETL_Log] ?, ?, ?, ?, ?, 0&#xA;/*&#xA; @RunID int,&#xA; @ExtractionProcessID INT,&#xA; @PackageName SYSNAME,&#xA; @SourceName SYSNAME,&#xA; @ExtractType bit,&#xA; @IsUpdate bit&#xA;&#xA;*/" />
		</Properties>
	</Component>
	<Component Name="Log Task status" URL="Package=Load_MSOIndividualProfile/Executable=Get Source table query/Executable=Delta Extract/Executable=WorkArea to Staging/EventHandler=OnPreExecute/Executable=Log Task status">
		<Properties>
			<Property Name="SqlStatementSource" Value="&#xA;EXEC [dbo].[prc_Update_ETL_Log] ?, ?, ?, ?, ?, 1&#xA;/*&#xA; @RunID int,&#xA; @ExtractionProcessID INT,&#xA; @PackageName SYSNAME,&#xA; @SourceName SYSNAME,&#xA; @ExtractType bit,&#xA; @IsUpdate bit&#xA;&#xA;*/" />
		</Properties>
	</Component>
	<Component Name="Fetch Delta from Staging" URL="Package=Load_MSOIndividualProfile/Executable=Get Source table query/Executable=Delta Extract/Executable=Staging to GenevaOne(Delta)/Component=Fetch Delta from Staging">
		<Mappings>
			<Mapping Usage="True" SourceColumn="UpdatedDate" DestinationColumn="UpdatedDate" />
			<Mapping Usage="True" SourceColumn="IndividualId" DestinationColumn="IndividualId" />
			<Mapping Usage="True" SourceColumn="GENEVA_Deleted_Flag" DestinationColumn="GENEVA_Deleted_Flag" />
			<Mapping Usage="True" SourceColumn="ContactAuthorizationThirdPartyID" DestinationColumn="ContactAuthorizationThirdPartyID" />
			<Mapping Usage="True" SourceColumn="GENEVA_Staging_Extraction_id" DestinationColumn="GENEVA_Staging_Extraction_id" />
			<Mapping Usage="True" SourceColumn="IndividualAddressID" DestinationColumn="IndividualAddressID" />
			<Mapping Usage="True" SourceColumn="Address1Txt" DestinationColumn="Address1Txt" />
			<Mapping Usage="True" SourceColumn="Address2Txt" DestinationColumn="Address2Txt" />
			<Mapping Usage="True" SourceColumn="Address3Txt" DestinationColumn="Address3Txt" />
			<Mapping Usage="True" SourceColumn="CarrierRouteCode" DestinationColumn="CarrierRouteCode" />
			<Mapping Usage="True" SourceColumn="CityName" DestinationColumn="CityName" />
			<Mapping Usage="True" SourceColumn="ContactAuthorizationID" DestinationColumn="ContactAuthorizationID" />
			<Mapping Usage="True" SourceColumn="CountryId" DestinationColumn="CountryId" />
			<Mapping Usage="True" SourceColumn="DepartmentName" DestinationColumn="DepartmentName" />
			<Mapping Usage="True" SourceColumn="DSFAddressTypeID" DestinationColumn="DSFAddressTypeID" />
			<Mapping Usage="True" SourceColumn="DSFDeliverabilityID" DestinationColumn="DSFDeliverabilityID" />
			<Mapping Usage="True" SourceColumn="IndividualAddressTypeID" DestinationColumn="IndividualAddressTypeID" />
			<Mapping Usage="True" SourceColumn="JobTitle" DestinationColumn="JobTitle" />
			<Mapping Usage="True" SourceColumn="LocalityName" DestinationColumn="LocalityName" />
			<Mapping Usage="True" SourceColumn="NCOAUndeliverableTypeID" DestinationColumn="NCOAUndeliverableTypeID" />
			<Mapping Usage="True" SourceColumn="PostalCode" DestinationColumn="PostalCode" />
			<Mapping Usage="True" SourceColumn="PostalCodeSuffix" DestinationColumn="PostalCodeSuffix" />
			<Mapping Usage="True" SourceColumn="ReportedUndeliverableID" DestinationColumn="ReportedUndeliverableID" />
			<Mapping Usage="True" SourceColumn="StateOrProvinceCode" DestinationColumn="StateOrProvinceCode" />
			<Mapping Usage="True" SourceColumn="TrilliumAddressQualityID" DestinationColumn="TrilliumAddressQualityID" />
		</Mappings>
	</Component>
	<Component Name="Row Count" URL="Package=Load_MSOIndividualProfile/Executable=Get Source table query/Executable=Delta Extract/Executable=Staging to GenevaOne(Delta)/Component=Row Count">
		<CollectionInformation />
	</Component>
	<Component Name="Lookup" URL="Package=Load_MSOIndividualProfile/Executable=Get Source table query/Executable=Delta Extract/Executable=Staging to GenevaOne(Delta)/Component=Lookup">
		<Properties>
			<Property Name="SqlCommand" Value="SELECT IndividualAddressID FROM MSO_IndividualAddress (NOLOCK)" />
			<Property Name="ReferenceMetadataXml" Value="&lt;referenceMetadata&gt;&lt;referenceColumns&gt;&lt;referenceColumn name=&quot;IndividualAddressID&quot; dataType=&quot;DT_I4&quot; length=&quot;0&quot; precision=&quot;0&quot; scale=&quot;0&quot; codePage=&quot;0&quot;/&gt;&lt;/referenceColumns&gt;&lt;/referenceMetadata&gt;" />
		</Properties>
		<CollectionInformation>
			<Collection Name="Lookup Input" Type="Input">
				<Properties />
				<Columns>
					<Column Name="IndividualAddressID">
						<Properties>
							<Property Name="JoinToReferenceColumn" Value="IndividualAddressID" />
							<Property Name="CopyFromReferenceColumn" Value="" />
						</Properties>
					</Column>
				</Columns>
			</Collection>
		</CollectionInformation>
	</Component>
	<Component Name="OLE DB Destination" URL="Package=Load_MSOIndividualProfile/Executable=Get Source table query/Executable=Delta Extract/Executable=Staging to GenevaOne(Delta)/Component=OLE DB Destination">
		<Properties>
			<Property Name="OpenRowset" Value="MSO_IndividualAddress" />
		</Properties>
		<Mappings>
			<Mapping Usage="True" SourceColumn="UpdatedDate" DestinationColumn="UpdatedDate" />
			<Mapping Usage="True" SourceColumn="GENEVA_Deleted_Flag" DestinationColumn="GENEVA_Deleted_Flag" />
			<Mapping Usage="True" SourceColumn="IndividualId" DestinationColumn="IndividualId" />
			<Mapping Usage="True" SourceColumn="ContactAuthorizationThirdPartyID" DestinationColumn="ContactAuthorizationThirdPartyID" />
			<Mapping Usage="True" SourceColumn="IndividualAddressID" DestinationColumn="IndividualAddressID" />
			<Mapping Usage="True" SourceColumn="Address1Txt" DestinationColumn="Address1Txt" />
			<Mapping Usage="True" SourceColumn="Address2Txt" DestinationColumn="Address2Txt" />
			<Mapping Usage="True" SourceColumn="Address3Txt" DestinationColumn="Address3Txt" />
			<Mapping Usage="True" SourceColumn="CarrierRouteCode" DestinationColumn="CarrierRouteCode" />
			<Mapping Usage="True" SourceColumn="CityName" DestinationColumn="CityName" />
			<Mapping Usage="True" SourceColumn="ContactAuthorizationID" DestinationColumn="ContactAuthorizationID" />
			<Mapping Usage="True" SourceColumn="CountryId" DestinationColumn="CountryId" />
			<Mapping Usage="True" SourceColumn="DepartmentName" DestinationColumn="DepartmentName" />
			<Mapping Usage="True" SourceColumn="DSFAddressTypeID" DestinationColumn="DSFAddressTypeID" />
			<Mapping Usage="True" SourceColumn="DSFDeliverabilityID" DestinationColumn="DSFDeliverabilityID" />
			<Mapping Usage="True" SourceColumn="IndividualAddressTypeID" DestinationColumn="IndividualAddressTypeID" />
			<Mapping Usage="True" SourceColumn="JobTitle" DestinationColumn="JobTitle" />
			<Mapping Usage="True" SourceColumn="LocalityName" DestinationColumn="LocalityName" />
			<Mapping Usage="True" SourceColumn="NCOAUndeliverableTypeID" DestinationColumn="NCOAUndeliverableTypeID" />
			<Mapping Usage="True" SourceColumn="PostalCode" DestinationColumn="PostalCode" />
			<Mapping Usage="True" SourceColumn="PostalCodeSuffix" DestinationColumn="PostalCodeSuffix" />
			<Mapping Usage="True" SourceColumn="ReportedUndeliverableID" DestinationColumn="ReportedUndeliverableID" />
			<Mapping Usage="True" SourceColumn="StateOrProvinceCode" DestinationColumn="StateOrProvinceCode" />
			<Mapping Usage="True" SourceColumn="TrilliumAddressQualityID" DestinationColumn="TrilliumAddressQualityID" />
			<Mapping Usage="True" SourceColumn="GENEVA_Staging_Extraction_id" DestinationColumn="GENEVA_ONE_Extraction_id" />
		</Mappings>
	</Component>
	<Component Name="Pub Command" URL="Package=Load_MSOIndividualProfile/Executable=Get Source table query/Executable=Delta Extract/Executable=Staging to GenevaOne(Delta)/Component=Pub Command">
		<Properties>
			<Property Name="SqlCommand" Value="UPDATE MSO_IndividualAddress SET UpdatedDate = ?, Address1Txt = ?, Address2Txt = ?, Address3Txt = ?, CarrierRouteCode = ?, CityName = ?, ContactAuthorizationID = ?, ContactAuthorizationThirdPartyID = ?, CountryId = ?, DepartmentName = ?, DSFAddressTypeID = ?, DSFDeliverabilityID = ?, IndividualAddressTypeID = ?, IndividualId = ?, JobTitle = ?, LocalityName = ?, NCOAUndeliverableTypeID = ?, PostalCode = ?, PostalCodeSuffix = ?, ReportedUndeliverableID = ?, StateOrProvinceCode = ?, TrilliumAddressQualityID = ?, GENEVA_ONE_Extraction_id = ? WHERE IndividualAddressID = ?" />
		</Properties>
		<Mappings>
			<Mapping Usage="True" SourceColumn="UpdatedDate" DestinationColumn="Param_0" />
			<Mapping Usage="True" SourceColumn="Address1Txt" DestinationColumn="Param_1" />
			<Mapping Usage="True" SourceColumn="Address2Txt" DestinationColumn="Param_2" />
			<Mapping Usage="True" SourceColumn="Address3Txt" DestinationColumn="Param_3" />
			<Mapping Usage="True" SourceColumn="CarrierRouteCode" DestinationColumn="Param_4" />
			<Mapping Usage="True" SourceColumn="CityName" DestinationColumn="Param_5" />
			<Mapping Usage="True" SourceColumn="ContactAuthorizationID" DestinationColumn="Param_6" />
			<Mapping Usage="True" SourceColumn="ContactAuthorizationThirdPartyID" DestinationColumn="Param_7" />
			<Mapping Usage="True" SourceColumn="CountryId" DestinationColumn="Param_8" />
			<Mapping Usage="True" SourceColumn="DepartmentName" DestinationColumn="Param_9" />
			<Mapping Usage="True" SourceColumn="DSFAddressTypeID" DestinationColumn="Param_10" />
			<Mapping Usage="True" SourceColumn="DSFDeliverabilityID" DestinationColumn="Param_11" />
			<Mapping Usage="True" SourceColumn="IndividualAddressTypeID" DestinationColumn="Param_12" />
			<Mapping Usage="True" SourceColumn="IndividualId" DestinationColumn="Param_13" />
			<Mapping Usage="True" SourceColumn="JobTitle" DestinationColumn="Param_14" />
			<Mapping Usage="True" SourceColumn="LocalityName" DestinationColumn="Param_15" />
			<Mapping Usage="True" SourceColumn="NCOAUndeliverableTypeID" DestinationColumn="Param_16" />
			<Mapping Usage="True" SourceColumn="PostalCode" DestinationColumn="Param_17" />
			<Mapping Usage="True" SourceColumn="PostalCodeSuffix" DestinationColumn="Param_18" />
			<Mapping Usage="True" SourceColumn="ReportedUndeliverableID" DestinationColumn="Param_19" />
			<Mapping Usage="True" SourceColumn="StateOrProvinceCode" DestinationColumn="Param_20" />
			<Mapping Usage="True" SourceColumn="TrilliumAddressQualityID" DestinationColumn="Param_21" />
			<Mapping Usage="True" SourceColumn="GENEVA_Staging_Extraction_id" DestinationColumn="Param_22" />
			<Mapping Usage="True" SourceColumn="IndividualAddressID" DestinationColumn="Param_23" />
		</Mappings>
	</Component>
	<Component Name="Log Task status" URL="Package=Load_MSOIndividualProfile/Executable=Get Source table query/Executable=Delta Extract/Executable=Staging to GenevaOne(Delta)/EventHandler=OnPostExecute/Executable=Log Task status">
		<Properties>
			<Property Name="SqlStatementSource" Value="&#xA;EXEC [dbo].[prc_Update_ETL_Log] ?, ?, ?, ?, ?, 0&#xA;/*&#xA; @RunID int,&#xA; @ExtractionProcessID INT,&#xA; @PackageName SYSNAME,&#xA; @SourceName SYSNAME,&#xA; @ExtractType bit,&#xA; @IsUpdate bit&#xA;&#xA;*/" />
		</Properties>
	</Component>
	<Component Name="Log Task status" URL="Package=Load_MSOIndividualProfile/Executable=Get Source table query/Executable=Delta Extract/Executable=Staging to GenevaOne(Delta)/EventHandler=OnPreExecute/Executable=Log Task status">
		<Properties>
			<Property Name="SqlStatementSource" Value="&#xA;EXEC [dbo].[prc_Update_ETL_Log] ?, ?, ?, ?, ?, 1&#xA;/*&#xA; @RunID int,&#xA; @ExtractionProcessID INT,&#xA; @PackageName SYSNAME,&#xA; @SourceName SYSNAME,&#xA; @ExtractType bit,&#xA; @IsUpdate bit&#xA;&#xA;*/" />
		</Properties>
	</Component>
	<Variable Name="MetadataConnectionString" URL="Package=Load_MSOIndividualProfile/Variable=MetadataConnectionString">
		<Properties>
			<Property Name="Value" Value="Data Source=PS0820;Initial Catalog=ETL_Meta;Integrated Security=SSPI;Provider=SQLNCLI.1;Auto Translate=False;" />
		</Properties>
	</Variable>
	<Variable Name="PartialStagingSQLStatement" URL="Package=Load_MSOIndividualProfile/Variable=PartialStagingSQLStatement">
		<Properties>
			<Property Name="Value" Value=" SELECT IndividualAddressID,UpdatedDate,Address1Txt,Address2Txt,Address3Txt,CarrierRouteCode,CityName,ContactAuthorizationID,ContactAuthorizationThirdPartyID,CountryId,DepartmentName,DSFAddressTypeID,DSFDeliverabilityID,IndividualAddressTypeID,IndividualId,JobTitle,LocalityName,NCOAUndeliverableTypeID,PostalCode,PostalCodeSuffix,ReportedUndeliverableID,StateOrProvinceCode,TrilliumAddressQualityID , [GENEVA_Deleted_Flag], [GENEVA_Staging_Extraction_id]  FROM [MSO_IndividualAddress] (NOLOCK)" />
		</Properties>
	</Variable>
	<Variable Name="PubConnectionString" URL="Package=Load_MSOIndividualProfile/Variable=PubConnectionString">
		<Properties>
			<Property Name="Value" Value="Data Source=PS0820;Initial Catalog=GenevaOne;Integrated Security=SSPI;Provider=SQLNCLI.1;Auto Translate=False;" />
		</Properties>
	</Variable>
	<Variable Name="SourceConnectionString" URL="Package=Load_MSOIndividualProfile/Variable=SourceConnectionString">
		<Properties>
			<Property Name="Value" Value="Data Source=ps0820;Initial Catalog=MSO_Source;Integrated Security=SSPI;Provider=SQLNCLI.1;Auto Translate=False;" />
		</Properties>
	</Variable>
	<Variable Name="SourceQuery" URL="Package=Load_MSOIndividualProfile/Variable=SourceQuery">
		<Properties>
			<Property Name="Value" Value=" EXECUTE  dbo.GetCustomerData   @Select = 'IndividualAddressID,UpdatedDate,Address1Txt,Address2Txt,Address3Txt,CarrierRouteCode,CityName,ContactAuthorizationID,ContactAuthorizationThirdPartyID,CountryId,DepartmentName,DSFAddressTypeID,DSFDeliverabilityID,IndividualAddressTypeID,IndividualId,JobTitle,LocalityName,NCOAUndeliverableTypeID,PostalCode,PostalCodeSuffix,ReportedUndeliverableID,StateOrProvinceCode,TrilliumAddressQualityID', @From = 'IndividualAddress', @Where = '1=1 AND UpdatedDate &gt; ''30 Dec 1899 00:00:00''' ,@InTableFilter='IndividualId in MSO_IndividualDataSourceTxlat'" />
		</Properties>
	</Variable>
	<Variable Name="StagingConnectionString" URL="Package=Load_MSOIndividualProfile/Variable=StagingConnectionString">
		<Properties>
			<Property Name="Value" Value="Data Source=PS0820;Initial Catalog=GenevaStaging;Integrated Security=SSPI;Provider=SQLNCLI.1;Auto Translate=False;" />
		</Properties>
	</Variable>
	<Variable Name="StagingSQLStatement" URL="Package=Load_MSOIndividualProfile/Variable=StagingSQLStatement">
		<Properties>
			<Property Name="Value" Value="SELECT IndividualAddressID,UpdatedDate,Address1Txt,Address2Txt,Address3Txt,CarrierRouteCode,CityName,ContactAuthorizationID,ContactAuthorizationThirdPartyID,CountryId,DepartmentName,DSFAddressTypeID,DSFDeliverabilityID,IndividualAddressTypeID,IndividualId,JobTitle,LocalityName,NCOAUndeliverableTypeID,PostalCode,PostalCodeSuffix,ReportedUndeliverableID,StateOrProvinceCode,TrilliumAddressQualityID , [GENEVA_Deleted_Flag], [GENEVA_Staging_Extraction_id]  FROM [MSO_IndividualAddress] (NOLOCK) WHERE Geneva_Staging_Extraction_ID=0" />
		</Properties>
	</Variable>
	<Variable Name="TableName" URL="Package=Load_MSOIndividualProfile/Variable=TableName">
		<Properties>
			<Property Name="Value" Value="MSO_IndividualAddress" />
		</Properties>
	</Variable>
	<Variable Name="WorkAreaConnectionString" URL="Package=Load_MSOIndividualProfile/Variable=WorkAreaConnectionString">
		<Properties>
			<Property Name="Value" Value="Data Source=PS0820;Initial Catalog=ETLWorkArea;Integrated Security=SSPI;Provider=SQLNCLI.1;Auto Translate=False;" />
		</Properties>
	</Variable>
	<ConnectionManager Name="ETLWorkArea">
		<Properties>
			<Property Name="ConnectionString" Value="Data Source=PS0820;Initial Catalog=ETLWorkArea;Integrated Security=SSPI;Provider=SQLNCLI.1;Auto Translate=False;" />
			<Property Name="ServerName" Value="PS0820" />
		</Properties>
	</ConnectionManager>
	<ConnectionManager Name="MetadataConnectionString">
		<Properties>
			<Property Name="ConnectionString" Value="Data Source=PS0820;Initial Catalog=ETL_Meta;Integrated Security=SSPI;Provider=SQLNCLI.1;Auto Translate=False;" />
			<Property Name="ServerName" Value="PS0820" />
		</Properties>
	</ConnectionManager>
	<ConnectionManager Name="PubConnectionString">
		<Properties>
			<Property Name="ConnectionString" Value="Data Source=PS0820;Initial Catalog=GenevaOne;Integrated Security=SSPI;Provider=SQLNCLI.1;Auto Translate=False;" />
			<Property Name="ServerName" Value="PS0820" />
		</Properties>
	</ConnectionManager>
	<ConnectionManager Name="SourceConnectionString">
		<Properties>
			<Property Name="ConnectionString" Value="Data Source=ps0820;Initial Catalog=MSO_Source;Integrated Security=SSPI;Provider=SQLNCLI.1;Auto Translate=False;" />
			<Property Name="InitialCatalog" Value="MSO_Source" />
			<Property Name="ServerName" Value="ps0820" />
		</Properties>
	</ConnectionManager>
	<ConnectionManager Name="StagingConnectionString">
		<Properties>
			<Property Name="ConnectionString" Value="Data Source=PS0820;Initial Catalog=GenevaStaging;Integrated Security=SSPI;Provider=SQLNCLI.1;Auto Translate=False;" />
			<Property Name="ServerName" Value="PS0820" />
		</Properties>
	</ConnectionManager>
</PackageChanges>